\d permissions (rowcount = 322) Table "public.permissions" Column | Type | Modifiers ------------+-----------------------------+---------------------------------------------------------- id | integer | not null default nextval('permissions_id_seq'::regclass) section | character varying(255) | subject | character varying(255) | action | character varying(255) | created_at | timestamp without time zone | updated_at | timestamp without time zone | access_key | boolean | default false Indexes: "permissions_pkey" PRIMARY KEY, btree (id) \d permissions_roles (rowcount = 5190) Table "public.permissions_roles" Column | Type | Modifiers ---------------+---------+---------------------------------------------------------------- permission_id | integer | role_id | integer | id | integer | not null default nextval('permissions_roles_id_seq'::regclass) Indexes: "permissions_roles_pkey" PRIMARY KEY, btree (id) "permissions_roles_permission_id" btree (permission_id) prime_production=# \d roles_users (rowcount = 23349) Table "public.roles_users" Column | Type | Modifiers ---------+---------+---------------------------------------------------------- role_id | integer | user_id | integer | id | integer | not null default nextval('roles_users_id_seq'::regclass) Indexes: "roles_users_pkey" PRIMARY KEY, btree (id) "index_roles_users_on_role_id_and_user_id" btree (role_id, user_id) \d accounts_users_permissions (rowcount = 3172) Table "public.accounts_users_permissions" Column | Type | Modifiers ------------------+-----------------------------+------------------------------------------------------------------------- id | integer | not null default nextval('accounts_users_permissions_id_seq'::regclass) accounts_user_id | integer | permission_id | integer | created_at | timestamp without time zone | not null updated_at | timestamp without time zone | not null Indexes: "accounts_users_permissions_pkey" PRIMARY KEY, btree (id) "accounts_users_permissions_permission_id" btree (permission_id) \d accounts_users (rowcount = 42506) Table "public.accounts_users" Column | Type | Modi fiers --------------------+-----------------------------+----------------------------- ------------------------------ id | integer | not null default nextval('st ores_users_id_seq'::regclass) account_id | integer | user_id | integer | du_2_permission_id | character varying(255) | employee | boolean | default false parent_id | integer | parent_type | character varying(255) | deleted_at | timestamp without time zone | Indexes: "stores_users_pkey" PRIMARY KEY, btree (id) "index_accounts_users_on_parent_id_and_parent_type" btree (parent_id, parent _type) "index_stores_users_on_store_id_and_user_id" btree (account_id, user_id) \d access_keys_permissions (rowcount = 1665) Table "public.access_keys_permissions" Column | Type | Modifiers ---------------+-----------------------------+---------------------------------------------------------------------- id | integer | not null default nextval('access_keys_permissions_id_seq'::regclass) access_key_id | integer | permission_id | integer | created_at | timestamp without time zone | not null updated_at | timestamp without time zone | not null Indexes: "access_keys_permissions_pkey" PRIMARY KEY, btree (id) "index_access_keys_permissions_on_access_key_id" btree (access_key_id) "index_access_keys_permissions_on_permission_id" btree (permission_id) prime_production=# \d access_keys_users (rowcount = 784) Table "public.access_keys_users" Column | Type | Modifiers ---------------+-----------------------------+---------------------------------------------------------------- id | integer | not null default nextval('access_keys_users_id_seq'::regclass) access_key_id | integer | user_id | integer | created_at | timestamp without time zone | not null updated_at | timestamp without time zone | not null Indexes: "access_keys_users_pkey" PRIMARY KEY, btree (id) "index_access_keys_users_on_access_key_id" btree (access_key_id) "index_access_keys_users_on_user_id" btree (user_id)